package c.francis.service.impl;

import java.util.Date;
import java.util.List;
import org.springframework.stereotype.Repository;

import c.francis.pojo.Subscription;
@Repository
public interface SubscriptionServiceImpl {
	List<Subscription> queryallSub( int mid);
	
	void deleteSubByNo(String no);
	
	Subscription querySubByNo(String no);
	
	void updateSubByNo(String no,String email,String phone,String linkman);
	
	void insertNewSub(int mid,String no,String linkman,String email,String phone,String status,Date cretime);
	
	int countsubbyyear(String year);
	
	void updateStatus(String no,String status);
}